Lucas Rayala
Lucas Rayala
-
Re: Auto Populate Contact List on Shared Smartsheet
Hi @ghansen, I believe you can use DataShuttle to populate a list of contacts. Here's a post where an individual did this: Data Shuttle - Update Dropdowns - Contact List — Smartsheet Community Otherw…1 · -
Re: Override Column Formula for Particular Cells
@LukeSmartsheet104, here's a quick workaround suggestion. Create an override column (call it "Override"). Assuming that "<Your Formula>" is your original formula, update it …3 · -
Re: How to count the number of times a substring appears within a string?
Hi @JLK, you can reference a quote using the special character CHAR(34). This formula: =COUNTIF(Track@row, CONTAINS("1", Track@row)) becomes this formula (you also need to use the @cell ref…1 · -
Re: NEED HELP WITH A BUNCH OF FORMULAS IN A SHEET SUMMARY
Hi @Angie F you're missing a comma after {Software}1 · -
Re: NEED HELP WITH A BUNCH OF FORMULAS IN A SHEET SUMMARY
Depends on what you are trying to sum. If you only want entries in the last week, use the formula I provided. If you need something else, let us know what you are trying to summarize. Also, be carefu…1 ·
